package com.system.provider;

import com.am.ui.grid.AbstractBaseGridProvider;
import com.system.uitls.SearchFilter;
import java.util.Map;

public class DressingProvider extends AbstractBaseGridProvider
{
  public String generateSql(Map<String, Object> map)
  {
    StringBuffer sf = new StringBuffer("SELECT r.id,d.place,d.scope,d.method,d.create_time,d.times,r.person_name,r.user_name FROM sys_dressing AS d,sys_patient_record AS r WHERE r.person_id=:personId AND r.id = d.record_id AND status='7'");

    sf.append(SearchFilter.getSearchSql(map, null));

    sf.append(" ORDER BY create_time DESC");
    setParamMap(map);
    return sf.toString();
  }
}